The following tables list the members exposed by SQLQueryScalar<TResult>.
Public Constructors
| Name | Description | |
|---|---|---|
 | SQLQueryScalar<TResult> Constructor | Default Constructor |
Protected Fields
| Name | Description | |
|---|---|---|
 | ContinueExecution | Defaults to true. Can be set to false to stop execution. (Inherited from MVPSI.JAMS.Activities.JAMSNativeActivityGeneric<TResult>) |
Public Properties
| Name | Description | |
|---|---|---|
 | CommandText | The SQL Query to run. |
| ConnectionString | The database connection string. |
| ContinueOnError | When true, the activity will not fail after a SQL error when running the query. |
| DisplayName | (Inherited from System.Activities.Activity) |
| Id | (Inherited from System.Activities.Activity) |
| LogSQL | When true, the SQL query is written to the log file. |
| Result | (Inherited from System.Activities.Activity<TResult>) |
| ResultType | (Inherited from System.Activities.ActivityWithResult) |
Protected Properties
| Name | Description | |
|---|---|---|
 | AbortOnTaskFailure | By default, if an exception occurs during Task execution we log and rethrow. (Inherited from MVPSI.JAMS.Activities.NonblockingNativeActivityGeneric<TResult>) |
| CanInduceIdle | Allows the activity to induce idle. (Inherited from MVPSI.JAMS.Activities.NonblockingNativeActivityGeneric<TResult>) |
| Constraints | (Inherited from System.Activities.Activity) |
| Implementation | (Inherited from System.Activities.NativeActivity<TResult>) |
| Task | Gets the System.Threading.Task which performs the activity's work. (Inherited from MVPSI.JAMS.Activities.NonblockingNativeActivityGeneric<TResult>) |
| UserState | Gets or sets a user-defined object associated with the current async activity (Inherited from MVPSI.JAMS.Activities.NonblockingNativeActivityGeneric<TResult>) |
Public Methods
| Name | Description | |
|---|---|---|
 | ResumeCommandBookmark | Resumes a bookmark created when starting an Activity. Supported responses are Release or Skip. (Inherited from MVPSI.JAMS.Activities.JAMSNativeActivityGeneric<TResult>) |
| ToString | (Inherited from System.Activities.Activity) |
Protected Methods
| Name | Description | |
|---|---|---|
 | Abort | Abort Activity (Inherited from MVPSI.JAMS.Activities.NonblockingNativeActivityGeneric<TResult>) |
| AfterExecute | Overridden. Sets the scalar result of the query execution |
| CacheMetadata | Overloaded. Registers Activity Metadata (Inherited from MVPSI.JAMS.Activities.NonblockingNativeActivityGeneric<TResult>) |
| Cancel | Cancels the Activity (Inherited from MVPSI.JAMS.Activities.NonblockingNativeActivityGeneric<TResult>) |
| Execute | Executes the Activity (Inherited from MVPSI.JAMS.Activities.NonblockingNativeActivityGeneric<TResult>) |
| ExecuteNonblocking | Overridden. Executes the SQL query and captures the scalar result |
| OnCreateDynamicUpdateMap | Overloaded. (Inherited from System.Activities.NativeActivity<TResult>) |
| PrepareToExecute | Overridden. Prepares execution of SQL script |
| UpdateInstance | (Inherited from System.Activities.NativeActivity<TResult>) |
See Also